home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
fare_context.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
932b
|
24 lines
/* RCSVER $Id: fare_context.sql,v 1.1 1999-06-03 13:14:28-05 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
*
* Name: fare_context.sql
* Date: 05/31/1999
* memo: Randy Wood
* Description: Create the fare_context table. This table contains
* derived probed data associated with fare entry and
* currency acceptance.
* Changes:
************************************************************************* */
CREATE TABLE fare_context
(
fare_context_id NUMBER(38),
fareset_id NUMBER(38),
cashbox_glid NUMBER(38),
cb_sernum VARCHAR2(20),
fs_date DATE, /* fareset date/time */
cb_date DATE, /* cashbox insert time */
driver_context_id NUMBER(38), /* references driver_context */
CONSTRAINT pk_fare_context PRIMARY KEY (fare_context_id)
);